﻿

-- =============================================
-- Author:		Naresh N Jamadagni
-- Create date: 21 May 2012
-- Description:	Delets all the processes for specified computer
-- =============================================
CREATE PROCEDURE [dbo].[AddServiceEntry]
(
			@CanPauseAndContinue bit,
			@CanStop bit,
			@DisplayName nvarchar(200),
			@Description nvarchar(500),
			@ServiceName nvarchar(200),
			@TypeId smallint,
			@StatusId tinyint,
			@ComputerId int,
			@StartModeId tinyint,
			@DesktopInteraction bit,
			@InstallDate datetime,
			@PathName nvarchar(300),
			@ProcessId int,
			@ServiceAccountName nvarchar(100)
           
)
AS

BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
   INSERT INTO [dbo].[Service]
           ([CanPauseAndContinue]
           ,[CanStop]
           ,[DisplayName]
           ,[Description]
           ,[ServiceName]
           ,[TypeId]
           ,[StatusId]
           ,[ComputerId]
           ,[StartModeId]
           ,[DesktopInteraction]
           ,[InstallDate]
           ,[PathName]
           ,[ProcessId]
           ,[ServiceAccountName])
     VALUES
           (@CanPauseAndContinue,
			@CanStop,
			@DisplayName,
			@Description,
			@ServiceName,
			@TypeId,
			@StatusId,
			@ComputerId,
			@StartModeId,
			@DesktopInteraction,
			@InstallDate,
			@PathName,
			@ProcessId,
			@ServiceAccountName);
END



